package com.czh.subject.infra.basic.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.czh.subject.infra.basic.entity.SubjectInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 题目信息表(SubjectInfo)表数据库访问层
 *
 * @author caozaihui
 * @since 2024-07-31 00:05:23
 */
@Mapper
public interface SubjectInfoMapper extends BaseMapper<SubjectInfo> {

     /** 
        * 
        * @param subjectInfo 实例对象
        * @author caozaihui  
        * @description  分页查询数据
        * @date 2024-07-31 00:05:23
        * @return 实例对象
     */
    List<SubjectInfo> selectSubjectInfoList(SubjectInfo subjectInfo);

    int countByCondition(@Param("subjectInfo") SubjectInfo subjectInfo,@Param("labelId") Long labelId, @Param("categoryId") Long categoryId);

    List<SubjectInfo> querySubjectInfoList(@Param("subjectInfo")SubjectInfo subjectInfo, @Param("categoryId")Long categoryId,
                                           @Param("labelId")Long labelId, @Param("start")int start, @Param("pageSize") Integer pageSize);

    SubjectInfo getAdjoinSubject(@Param("subjectId")Long subjectId,@Param("categoryId")Long categoryId, @Param("labelId")Long labelId, @Param("i") int i);
}

